| bedrooms_per_room | latitude | rooms_per_household | ocean_proximity_NEAR OCEAN | ocean_proximity_ISLAND | housing_median_age | ocean_proximity_INLAND | ocean_proximity_1H OCEAN | population | median_income | households | total_rooms | population_per_household | longitude | ocean_proximity_NEAR BAY | median_house_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | -0.242420 | 1.336628 | 0.071477 | 0.000000 | 0.000000 | -0.128215 | 0.000000 | 1.000000 | 0.476176 | -0.186275 | 0.714983 | 0.771483 | -0.350855 | -1.650449 | 0.000000 | 187800.000000 |
| 1 | 0.360366 | -0.749932 | -0.858892 | 0.000000 | 0.000000 | 1.624665 | 0.000000 | 1.000000 | -0.537912 | -0.751947 | -0.309735 | -0.546425 | -0.583863 | 0.610133 | 0.000000 | 136600.000000 |
| 2 | 2.217308 | 1.013819 | -1.510273 | 0.000000 | 0.000000 | 1.863694 | 0.000000 | 0.000000 | 0.779536 | -0.969181 | 1.752274 | 0.465798 | -0.837926 | -1.425888 | 1.000000 | 400000.000000 |
| 3 | -0.528531 | -0.141742 | 0.129676 | 0.000000 | 0.000000 | -1.642065 | 1.000000 | 0.000000 | 3.741558 | 0.664143 | 3.622509 | 3.790882 | -0.215725 | 0.240854 | 0.000000 | 106300.000000 |
| 4 | -0.177948 | 2.880494 | 0.405768 | 0.000000 | 0.000000 | 0.907578 | 1.000000 | 0.000000 | 0.080725 | -1.166189 | 0.205767 | 0.412735 | -0.269346 | -1.026668 | 0.000000 | 43500.000000 |
| bedrooms_per_room | latitude | rooms_per_household | ocean_proximity_NEAR OCEAN | ocean_proximity_ISLAND | housing_median_age | ocean_proximity_INLAND | ocean_proximity_1H OCEAN | population | median_income | households | total_rooms | population_per_household | longitude | ocean_proximity_NEAR BAY | median_house_value | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16507 | -1.017579 | -0.885605 | 1.172346 | 0.000000 | 0.000000 | -1.243683 | 1.000000 | 0.000000 | 0.272492 | 0.118410 | 0.086322 | 0.603645 | 0.216146 | 1.313757 | 0.000000 | 132300.000000 |
| 16508 | -0.223213 | -0.866891 | -0.048620 | 0.000000 | 0.000000 | -1.004654 | 0.000000 | 1.000000 | 0.505428 | -0.995673 | 0.180621 | 0.184336 | 0.413046 | 1.144089 | 0.000000 | 101300.000000 |
| 16509 | -0.434002 | 0.747151 | 0.226369 | 0.000000 | 0.000000 | 1.385636 | 0.000000 | 1.000000 | 2.530355 | 0.795691 | 3.622509 | 3.790882 | -0.772987 | -1.206317 | 0.000000 | 500001.000000 |
| 16510 | -0.629877 | -0.815429 | 0.095516 | 0.000000 | 0.000000 | -0.207891 | 0.000000 | 1.000000 | -0.499992 | 0.757178 | -0.668072 | -0.605255 | 0.390046 | 0.739879 | 0.000000 | 244900.000000 |
| 16511 | 1.259266 | -0.852856 | -0.986498 | 1.000000 | 0.000000 | 0.110814 | 0.000000 | 0.000000 | 1.688531 | -1.177355 | 0.639544 | 0.102436 | 1.186704 | 0.689976 | 0.000000 | 117600.000000 |
No missing values in data
No Infinity values
No Missing Values
No duplicate variables
| N | < (mean-3*std) | > (mean+3*std) | < (1stQ - 1.5 * IQR) | > (3rdQ + 1.5 * IQR) | -inf | +inf | |
|---|---|---|---|---|---|---|---|
| Feature | |||||||
| bedrooms_per_room | 16512 | 0 | 283 | 0 | 481 | 0 | 0 |
| rooms_per_household | 16512 | 3 | 201 | 31 | 361 | 0 | 0 |
| ocean_proximity_NEAR OCEAN | 16512 | 0 | 0 | 0 | 2149 | 0 | 0 |
| ocean_proximity_ISLAND | 16512 | 0 | 4 | 0 | 4 | 0 | 0 |
| population | 16512 | 0 | 418 | 0 | 970 | 0 | 0 |
| median_income | 16512 | 0 | 309 | 0 | 539 | 0 | 0 |
| households | 16512 | 0 | 458 | 0 | 977 | 0 | 0 |
| total_rooms | 16512 | 0 | 446 | 0 | 1033 | 0 | 0 |
| population_per_household | 16512 | 0 | 76 | 6 | 573 | 0 | 0 |
| ocean_proximity_NEAR BAY | 16512 | 0 | 0 | 0 | 1816 | 0 | 0 |
| median_house_value | 16512 | 0 | 0 | 0 | 857 | 0 | 0 |
| Variable Name | Datatype | No of Unique | Samples | Mean | Standard Deviation | Min | 25th percentile | Median | 75th percentile | Max | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | bedrooms_per_room | float64 | 15272 | [-0.24241977089783234, 0.3603662599994412, 2.2173084088914905, -0.5285306586234289, -0.17794801218618386] | -0.005617 | 0.981997 | -2.154586 | -0.693672 | -0.167725 | 0.531165 | 3.000091 |
| 1 | households | float64 | 1345 | [0.7149830926678219, -0.309734886404174, 1.7522742984768978, 3.000090847149692, 0.20576740981609387] | -0.013604 | 0.954175 | -1.529338 | -0.652355 | -0.243725 | 0.369219 | 3.000091 |
| 2 | housing_median_age | float64 | 52 | [-0.12821464153138798, 1.6246649467888925, 1.86369398155984, -1.6420651950807212, 0.9075778424760504] | 0.000000 | 1.000030 | -2.199800 | -0.845302 | 0.031138 | 0.668549 | 1.863694 |
| 3 | latitude | float64 | 849 | [1.3366276049561825, -0.749931804016589, 1.0138190865276602, -0.14174184175995203, 2.8804944322230357] | -0.000000 | 1.000030 | -1.442333 | -0.792037 | -0.642329 | 0.976392 | 2.960027 |
| 4 | longitude | float64 | 826 | [-1.6504488602891274, 0.6101325040076349, -1.4258877976106397, 0.24085431204746005, -1.0266681306266656] | -0.000000 | 1.000030 | -2.389005 | -1.107760 | 0.535279 | 0.779801 | 2.541358 |
| 5 | median_house_value | float64 | 3666 | [187800.0, 136600.0, 400000.0, 106300.0, 43500.0] | 206705.400073 | 115473.008383 | 14999.000000 | 119600.000000 | 179250.000000 | 264825.000000 | 500001.000000 |
| 6 | median_income | float64 | 10639 | [-0.18627468963237473, -0.7519473218425545, -0.9691806531566259, 0.6641428127345657, -1.1661890086992588] | -0.004701 | 0.985188 | -1.900327 | -0.725228 | -0.171576 | 0.521030 | 3.000091 |
| 7 | population | float64 | 3253 | [0.47617590290407275, -0.5379122975728626, 0.7795356209954636, 3.000090847149691, 0.08072484182065243] | -0.015262 | 0.947498 | -1.505413 | -0.653839 | -0.244303 | 0.361333 | 3.000091 |
| 8 | population_per_household | float64 | 15200 | [-0.3508550292800474, -0.5838633123806838, -0.8379258467560565, -0.21572499296054662, -0.26934570848237793] | -0.024342 | 0.684256 | -2.033807 | -0.467866 | -0.117050 | 0.300883 | 3.000091 |
| 9 | rooms_per_household | float64 | 15462 | [0.07147650203884061, -0.8588923488944343, -1.510273481973187, 0.129675836190255, 0.40576790785708616] | -0.019016 | 0.920716 | -3.000091 | -0.646441 | -0.085210 | 0.502597 | 3.000091 |
| 10 | total_rooms | float64 | 5040 | [0.7714833974305678, -0.5464250776400783, 0.465797843037814, 3.000090847149692, 0.4127354449168077] | -0.017484 | 0.939109 | -1.473287 | -0.638708 | -0.246507 | 0.337756 | 3.000091 |
| Variable Name | Datatype | No of Unique | Samples | Mode | Mode Freq | Mode Freq % | |
|---|---|---|---|---|---|---|---|
| 0 | ocean_proximity_INLAND | float64 | 2 | [0.0, 1.0] | 0.000000 | 11294.000000 | 68.398740 |
| 1 | ocean_proximity_1H OCEAN | float64 | 2 | [1.0, 0.0] | 0.000000 | 9187.000000 | 55.638324 |
| 2 | ocean_proximity_NEAR OCEAN | float64 | 2 | [0.0, 1.0] | 0.000000 | 14363.000000 | 86.985223 |
| 3 | ocean_proximity_ISLAND | float64 | 2 | [0.0, 1.0] | 0.000000 | 16508.000000 | 99.975775 |
| 4 | ocean_proximity_NEAR BAY | float64 | 2 | [0.0, 1.0] | 0.000000 | 14696.000000 | 89.001938 |
No categorical variables in data.
| Variable 1 | Variable 2 | Corr Coef | Abs Corr Coef | |
|---|---|---|---|---|
| 0 | median_income | median_house_value | 0.696813 | 0.696813 |
| 1 | median_house_value | median_income | 0.696813 | 0.696813 |
| 2 | median_house_value | ocean_proximity_INLAND | -0.482378 | 0.482378 |
| 3 | ocean_proximity_INLAND | median_house_value | -0.482378 | 0.482378 |
| 4 | rooms_per_household | median_house_value | 0.300411 | 0.300411 |
| 5 | median_house_value | rooms_per_household | 0.300411 | 0.300411 |
| 6 | bedrooms_per_room | median_house_value | -0.288113 | 0.288113 |
| 7 | median_house_value | bedrooms_per_room | -0.288113 | 0.288113 |
| 8 | median_house_value | population_per_household | -0.267078 | 0.267078 |
| 9 | population_per_household | median_house_value | -0.267078 | 0.267078 |
| 10 | median_house_value | ocean_proximity_1H OCEAN | 0.258098 | 0.258098 |
| 11 | ocean_proximity_1H OCEAN | median_house_value | 0.258098 | 0.258098 |
| 12 | total_rooms | median_house_value | 0.161885 | 0.161885 |
| 13 | median_house_value | total_rooms | 0.161885 | 0.161885 |
| 14 | ocean_proximity_NEAR BAY | median_house_value | 0.156986 | 0.156986 |
| 15 | median_house_value | ocean_proximity_NEAR BAY | 0.156986 | 0.156986 |
| 16 | median_house_value | latitude | -0.145757 | 0.145757 |
| 17 | latitude | median_house_value | -0.145757 | 0.145757 |
| 18 | median_house_value | ocean_proximity_NEAR OCEAN | 0.138237 | 0.138237 |
| 19 | ocean_proximity_NEAR OCEAN | median_house_value | 0.138237 | 0.138237 |
| 20 | housing_median_age | median_house_value | 0.107227 | 0.107227 |
| 21 | median_house_value | housing_median_age | 0.107227 | 0.107227 |
| 22 | households | median_house_value | 0.077447 | 0.077447 |
| 23 | median_house_value | households | 0.077447 | 0.077447 |
| 24 | median_house_value | longitude | -0.042943 | 0.042943 |
| 25 | longitude | median_house_value | -0.042943 | 0.042943 |
| 26 | population | median_house_value | -0.029624 | 0.029624 |
| 27 | median_house_value | population | -0.029624 | 0.029624 |
| 28 | ocean_proximity_ISLAND | median_house_value | 0.026553 | 0.026553 |
| 29 | median_house_value | ocean_proximity_ISLAND | 0.026553 | 0.026553 |